/*
 Navicat Premium Data Transfer

 Source Server         : 124.222.161.246
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 124.222.161.246:3306
 Source Schema         : search

 Target Server Type    : MySQL
 Target Server Version : 50650
 File Encoding         : 65001

 Date: 03/03/2022 17:01:44
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `username` varchar(255) DEFAULT NULL COMMENT '姓名(登录名)',
  `password` varchar(255) DEFAULT NULL COMMENT '登录密码'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for admin_user_info
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_info`;
CREATE TABLE `admin_user_info` (
  `roles` varchar(255) DEFAULT NULL COMMENT '角色(可能存在问题)',
  `introduction` varchar(255) DEFAULT NULL COMMENT '介绍',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '图标'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='admin登录时需要的info信息';

-- ----------------------------
-- Records of admin_user_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_title` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='寻物类别';

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES (1, '我是微信端寻物类别');
COMMIT;

-- ----------------------------
-- Table structure for find_list
-- ----------------------------
DROP TABLE IF EXISTS `find_list`;
CREATE TABLE `find_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fl_id` int(11) DEFAULT NULL COMMENT '索引',
  `fl_imgurl` varchar(255) DEFAULT NULL COMMENT '详情页图片地址',
  `fl_imgdesc` varchar(255) DEFAULT NULL COMMENT '图片描述',
  `fl_status` varchar(255) DEFAULT NULL COMMENT '物品状态',
  `fl_createtime` datetime DEFAULT NULL COMMENT '发布时间',
  `version` int(11) DEFAULT NULL COMMENT '1',
  `fl_name` varchar(255) DEFAULT NULL COMMENT '招领人',
  `fl_contact` varchar(255) DEFAULT NULL COMMENT '联系方式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='待招领物品详情表';

-- ----------------------------
-- Records of find_list
-- ----------------------------
BEGIN;
INSERT INTO `find_list` VALUES (1, 1, 'http://localhost:8091/474f4082-f2b6-4a18-8dca-1d27ec608bdf.jpg', '微信端待招领物品详情信', '未找到', '2022-03-03 00:00:00', NULL, '16766666', '6666');
COMMIT;

-- ----------------------------
-- Table structure for goods_detail
-- ----------------------------
DROP TABLE IF EXISTS `goods_detail`;
CREATE TABLE `goods_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `d_imgurl` varchar(255) DEFAULT NULL COMMENT '新增图片信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='物品详情页信息';

-- ----------------------------
-- Records of goods_detail
-- ----------------------------
BEGIN;
INSERT INTO `goods_detail` VALUES (2, 'http://localhost:8091/7f18ae78-1690-4f33-9ad1-96724685f6c6.jpg');
COMMIT;

-- ----------------------------
-- Table structure for goodsfirst
-- ----------------------------
DROP TABLE IF EXISTS `goodsfirst`;
CREATE TABLE `goodsfirst` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `g_id` int(11) DEFAULT NULL COMMENT '索引',
  `imgurl` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `imgname` varchar(255) DEFAULT NULL COMMENT '图片名称',
  `imgdesc` varchar(255) DEFAULT NULL COMMENT '图片描述',
  `status` varchar(255) DEFAULT NULL COMMENT '图片状态',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `version` int(11) DEFAULT NULL COMMENT '乐观锁',
  `lostname` varchar(255) DEFAULT NULL COMMENT '遗失者姓名',
  `contact` varchar(255) DEFAULT NULL COMMENT '联系方式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='首页展示的物品信息';

-- ----------------------------
-- Records of goodsfirst
-- ----------------------------
BEGIN;
INSERT INTO `goodsfirst` VALUES (2, 1, 'https://orginly.oss-cn-beijing.aliyuncs.com/shiwu/1eb161c7-d60e-44f9-86f6-2f8fb41f012d.jpg', '微信首页物品', '微信首页物品', '未找到', '2022-03-03 08:00:00', NULL, '1888888888', '777777');
COMMIT;

-- ----------------------------
-- Table structure for pc_attestation
-- ----------------------------
DROP TABLE IF EXISTS `pc_attestation`;
CREATE TABLE `pc_attestation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(255) DEFAULT NULL COMMENT '被认领的物品名称',
  `user_name` varchar(255) DEFAULT NULL COMMENT '认领人的姓名',
  `contact` varchar(255) DEFAULT NULL COMMENT '认领人的联系方式',
  `number` int(11) DEFAULT NULL COMMENT '认领人的学号或工号',
  `address` varchar(255) DEFAULT NULL COMMENT '认领人的地址',
  `img_url` varchar(255) DEFAULT NULL COMMENT '认领人的证件照',
  `create_time` datetime DEFAULT NULL COMMENT '认领时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='认领信息登记';

-- ----------------------------
-- Records of pc_attestation
-- ----------------------------
BEGIN;
INSERT INTO `pc_attestation` VALUES (1, '被认领的物品名称', '冯某人', '1888888888', 65666666, '全额', 'http://localhost:8091/2a04dc92-9362-4941-972c-05ddc6b13e94.jpg', '2022-03-03 13:24:52', NULL);
INSERT INTO `pc_attestation` VALUES (2, '微信首页物品', 'qqqqq', '18169996666', 4444444, 'qqqqq', 'http://192.168.5.109:8091/ead0d2e5-2b98-4018-87ca-2d662b1670ad.jpg', '2022-03-03 13:52:25', NULL);
INSERT INTO `pc_attestation` VALUES (3, '微信首页物品', '丽丽', '17688806952', 2233, '广西理工职业技术学院', 'https://orginly.oss-cn-beijing.aliyuncs.com/shiwu/6c0655f6-c104-4bc6-80de-d5cf68d5b401.jpg', '2022-03-03 16:14:15', NULL);
COMMIT;

-- ----------------------------
-- Table structure for pc_carousel
-- ----------------------------
DROP TABLE IF EXISTS `pc_carousel`;
CREATE TABLE `pc_carousel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='PC端轮播图';

-- ----------------------------
-- Records of pc_carousel
-- ----------------------------
BEGIN;
INSERT INTO `pc_carousel` VALUES (1, 'http://localhost:8091/e546ace6-28f3-4318-8dc5-d8642f86daa7.jpg', '2022-03-03 13:24:21', NULL);
INSERT INTO `pc_carousel` VALUES (2, 'http://localhost:8091/786a979a-aa10-410c-bee2-f4e6e2ccca72.jpg', '2022-03-03 15:10:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for pc_goods_king
-- ----------------------------
DROP TABLE IF EXISTS `pc_goods_king`;
CREATE TABLE `pc_goods_king` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kind` varchar(255) DEFAULT NULL COMMENT '物品种类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='物品种类';

-- ----------------------------
-- Records of pc_goods_king
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for pc_goodsdetail
-- ----------------------------
DROP TABLE IF EXISTS `pc_goodsdetail`;
CREATE TABLE `pc_goodsdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `panelId` int(11) DEFAULT NULL COMMENT '索引',
  `kindId` int(11) DEFAULT NULL COMMENT '物品种类索引',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '物品名称',
  `goods_detail` varchar(255) DEFAULT NULL COMMENT '"物品详情描述"',
  `status` varchar(255) DEFAULT NULL COMMENT '物品状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='PC端物品详情信息';

-- ----------------------------
-- Records of pc_goodsdetail
-- ----------------------------
BEGIN;
INSERT INTO `pc_goodsdetail` VALUES (1, 1, 1, 2, 'http://localhost:8091/763ef8d8-607e-4729-95e4-54ece5034b08.jpg', '2022-03-03 13:23:04', NULL, '我是pc端物品', '我是pc端物品', '未找到');
COMMIT;

-- ----------------------------
-- Table structure for pc_recent
-- ----------------------------
DROP TABLE IF EXISTS `pc_recent`;
CREATE TABLE `pc_recent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `panelId` int(11) DEFAULT NULL COMMENT '索引',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '物品名称',
  `goods_detail` varchar(255) DEFAULT NULL COMMENT '"物品详情描述"',
  `status` varchar(255) DEFAULT NULL COMMENT '物品状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='PC端最新信息';

-- ----------------------------
-- Records of pc_recent
-- ----------------------------
BEGIN;
INSERT INTO `pc_recent` VALUES (1, 2, 2, 'http://localhost:8091/1c6c1cfd-9275-42d0-b67c-3acebeb362df.jpg', '2022-03-03 13:24:05', NULL, '我是pc端最新物品信息', '我是pc端最新物品信息期去', '未找到主人');
COMMIT;

-- ----------------------------
-- Table structure for pc_urgent
-- ----------------------------
DROP TABLE IF EXISTS `pc_urgent`;
CREATE TABLE `pc_urgent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `panelId` int(11) DEFAULT NULL COMMENT '索引',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '物品名称',
  `goods_detail` varchar(255) DEFAULT NULL COMMENT '"物品详情描述"',
  `status` varchar(255) DEFAULT NULL COMMENT '物品状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='PC端急需物品';

-- ----------------------------
-- Records of pc_urgent
-- ----------------------------
BEGIN;
INSERT INTO `pc_urgent` VALUES (1, 1, 0, 'http://localhost:8091/bca1bac4-6ab4-436b-ac26-989484798fa3.jpg', '2022-03-03 13:21:19', NULL, '需要女朋友', '漂亮', '未找到');
COMMIT;

-- ----------------------------
-- Table structure for pc_user
-- ----------------------------
DROP TABLE IF EXISTS `pc_user`;
CREATE TABLE `pc_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pc_user
-- ----------------------------
BEGIN;
INSERT INTO `pc_user` VALUES (1, 'lzscxb', '111111');
COMMIT;

-- ----------------------------
-- Table structure for s_find
-- ----------------------------
DROP TABLE IF EXISTS `s_find`;
CREATE TABLE `s_find` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `f_click` int(11) DEFAULT NULL COMMENT '浏览次数',
  `f_img` varchar(255) DEFAULT NULL COMMENT '首页图片信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='招领信息表';

-- ----------------------------
-- Records of s_find
-- ----------------------------
BEGIN;
INSERT INTO `s_find` VALUES (1, 1, 'http://localhost:8091/4db22477-01a5-4958-861b-ecbbade50739.jpg');
COMMIT;

-- ----------------------------
-- Table structure for s_user
-- ----------------------------
DROP TABLE IF EXISTS `s_user`;
CREATE TABLE `s_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `roles` varchar(10) DEFAULT '0',
  `introduction` varchar(255) DEFAULT NULL COMMENT '介绍',
  `avatar` varchar(255) DEFAULT NULL COMMENT '图标',
  `sex` varchar(255) DEFAULT '0' COMMENT '性别',
  `email` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of s_user
-- ----------------------------
BEGIN;
INSERT INTO `s_user` VALUES (4, '18166669999', '111111', '0', NULL, NULL, '0', NULL, NULL);
INSERT INTO `s_user` VALUES (6, '17688806952', '17688806952', '0', NULL, NULL, '0', NULL, NULL);
INSERT INTO `s_user` VALUES (7, '17688888888', '17688888888', '0', NULL, NULL, '0', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for unbo
-- ----------------------------
DROP TABLE IF EXISTS `unbo`;
CREATE TABLE `unbo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgUrl` varchar(255) DEFAULT NULL COMMENT '存储图片的地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='首页轮播图';

-- ----------------------------
-- Records of unbo
-- ----------------------------
BEGIN;
INSERT INTO `unbo` VALUES (3, 'https://orginly.oss-cn-beijing.aliyuncs.com/shiwu/081af8ca-95ac-4d29-82ed-8dcac8bced09.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
